﻿CREATE VIEW [dbo].[Vw_EmployeeWithManager]
	AS SELECT e.*, m.Name ManagerName, m.Title ManagerTitle, m.Address ManagerAddress FROM [dbo].[Employee] e
	LEFT JOIN [dbo].[Employee] m on e.ManagerId = m.Id
